{
  "statement":"with cs_ui as (select cs_item_sk ,sum(cs_ext_list_price) as sale,sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit) as refund from catalog_sales ,catalog_returns where cs_item_sk \u003d cr_item_sk and cs_order_number \u003d cr_order_number group by cs_item_sk having sum(cs_ext_list_price)\u003e2*sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit)), cross_sales as (select i_product_name product_name ,i_item_sk item_sk ,s_store_name store_name ,s_zip store_zip ,ad1.ca_street_number b_street_number ,ad1.ca_street_name b_street_name ,ad1.ca_city b_city ,ad1.ca_zip b_zip ,ad2.ca_street_number c_street_number ,ad2.ca_street_name c_street_name ,ad2.ca_city c_city ,ad2.ca_zip c_zip ,d1.d_year as syear ,d2.d_year as fsyear ,d3.d_year s2year ,count(*) cnt ,sum(ss_wholesale_cost) s1 ,sum(ss_list_price) s2 ,sum(ss_coupon_amt) s3 FROM   store_sales ,store_returns ,cs_ui ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,customer ,customer_demographics cd1 ,customer_demographics cd2 ,promotion ,household_demographics hd1 ,household_demographics hd2 ,customer_address ad1 ,customer_address ad2 ,income_band ib1 ,income_band ib2 ,item WHERE  ss_store_sk \u003d s_store_sk AND ss_sold_date_sk \u003d d1.d_date_sk AND ss_customer_sk \u003d c_customer_sk AND ss_cdemo_sk\u003d cd1.cd_demo_sk AND ss_hdemo_sk \u003d hd1.hd_demo_sk AND ss_addr_sk \u003d ad1.ca_address_sk and ss_item_sk \u003d i_item_sk and ss_item_sk \u003d sr_item_sk and ss_ticket_number \u003d sr_ticket_number and ss_item_sk \u003d cs_ui.cs_item_sk and c_current_cdemo_sk \u003d cd2.cd_demo_sk AND c_current_hdemo_sk \u003d hd2.hd_demo_sk AND c_current_addr_sk \u003d ad2.ca_address_sk and c_first_sales_date_sk \u003d d2.d_date_sk and c_first_shipto_date_sk \u003d d3.d_date_sk and ss_promo_sk \u003d p_promo_sk and hd1.hd_income_band_sk \u003d ib1.ib_income_band_sk and hd2.hd_income_band_sk \u003d ib2.ib_income_band_sk and cd1.cd_marital_status \u003c\u003e cd2.cd_marital_status and i_color in (\u0027purple\u0027,\u0027burlywood\u0027,\u0027indian\u0027,\u0027spring\u0027,\u0027floral\u0027,\u0027medium\u0027) and i_current_price between 64 and 64 + 10 and i_current_price between 64 + 1 and 64 + 15 group by i_product_name ,i_item_sk ,s_store_name ,s_zip ,ad1.ca_street_number ,ad1.ca_street_name ,ad1.ca_city ,ad1.ca_zip ,ad2.ca_street_number ,ad2.ca_street_name ,ad2.ca_city ,ad2.ca_zip ,d1.d_year ,d2.d_year ,d3.d_year ) select cs1.product_name ,cs1.store_name ,cs1.store_zip ,cs1.b_street_number ,cs1.b_street_name ,cs1.b_city ,cs1.b_zip ,cs1.c_street_number ,cs1.c_street_name ,cs1.c_city ,cs1.c_zip ,cs1.syear ,cs1.cnt ,cs1.s1 as s11 ,cs1.s2 as s21 ,cs1.s3 as s31 ,cs2.s1 as s12 ,cs2.s2 as s22 ,cs2.s3 as s32 ,cs2.syear ,cs2.cnt from cross_sales cs1,cross_sales cs2 where cs1.item_sk\u003dcs2.item_sk and cs1.syear \u003d 1999 and cs2.syear \u003d 1999 + 1 and cs2.cnt \u003c\u003d cs1.cnt and cs1.store_name \u003d cs2.store_name and cs1.store_zip \u003d cs2.store_zip order by cs1.product_name ,cs1.store_name ,cs2.cnt ,cs1.s1 ,cs2.s1",
  "table_meta":{
    "standard_sqlset_1618283896.catalog_returns":"CREATE TABLE `catalog_returns` (\n  `cr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cr_order_number` int(11) NOT NULL COMMENT \"\",\n  `cr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `cr_returned_time_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_call_center_sk` int(11) NULL COMMENT \"\",\n  `cr_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cr_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cr_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cr_reason_sk` int(11) NULL COMMENT \"\",\n  `cr_return_quantity` int(11) NULL COMMENT \"\",\n  `cr_return_amount` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_amt_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cr_fee` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cr_refunded_cash` decimal(7, 2) NULL COMMENT \"\",\n  `cr_reversed_charge` decimal(7, 2) NULL COMMENT \"\",\n  `cr_store_credit` decimal(7, 2) NULL COMMENT \"\",\n  `cr_net_loss` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cr_item_sk`, `cr_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cr_item_sk`, `cr_order_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.catalog_sales":"CREATE TABLE `catalog_sales` (\n  `cs_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cs_order_number` int(11) NOT NULL COMMENT \"\",\n  `cs_sold_date_sk` int(11) NULL COMMENT \"\",\n  `cs_sold_time_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_date_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_call_center_sk` int(11) NULL COMMENT \"\",\n  `cs_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cs_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cs_promo_sk` int(11) NULL COMMENT \"\",\n  `cs_quantity` int(11) NULL COMMENT \"\",\n  `cs_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_discount_amt` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_coupon_amt` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_profit` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cs_item_sk`, `cs_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cs_item_sk`, `cs_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.customer":"CREATE TABLE `customer` (\n  `c_customer_sk` int(11) NOT NULL COMMENT \"\",\n  `c_customer_id` char(16) NOT NULL COMMENT \"\",\n  `c_current_cdemo_sk` int(11) NULL COMMENT \"\",\n  `c_current_hdemo_sk` int(11) NULL COMMENT \"\",\n  `c_current_addr_sk` int(11) NULL COMMENT \"\",\n  `c_first_shipto_date_sk` int(11) NULL COMMENT \"\",\n  `c_first_sales_date_sk` int(11) NULL COMMENT \"\",\n  `c_salutation` char(10) NULL COMMENT \"\",\n  `c_first_name` char(20) NULL COMMENT \"\",\n  `c_last_name` char(30) NULL COMMENT \"\",\n  `c_preferred_cust_flag` char(1) NULL COMMENT \"\",\n  `c_birth_day` int(11) NULL COMMENT \"\",\n  `c_birth_month` int(11) NULL COMMENT \"\",\n  `c_birth_year` int(11) NULL COMMENT \"\",\n  `c_birth_country` varchar(20) NULL COMMENT \"\",\n  `c_login` char(13) NULL COMMENT \"\",\n  `c_email_address` char(50) NULL COMMENT \"\",\n  `c_last_review_date` char(10) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`c_customer_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`c_customer_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.customer_address":"CREATE TABLE `customer_address` (\n  `ca_address_sk` int(11) NOT NULL COMMENT \"\",\n  `ca_address_id` char(16) NOT NULL COMMENT \"\",\n  `ca_street_number` char(10) NULL COMMENT \"\",\n  `ca_street_name` varchar(60) NULL COMMENT \"\",\n  `ca_street_type` char(15) NULL COMMENT \"\",\n  `ca_suite_number` char(10) NULL COMMENT \"\",\n  `ca_city` varchar(60) NULL COMMENT \"\",\n  `ca_county` varchar(30) NULL COMMENT \"\",\n  `ca_state` char(2) NULL COMMENT \"\",\n  `ca_zip` char(10) NULL COMMENT \"\",\n  `ca_country` varchar(20) NULL COMMENT \"\",\n  `ca_gmt_offset` decimal(5, 2) NULL COMMENT \"\",\n  `ca_location_type` char(20) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ca_address_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ca_address_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.customer_demographics":"CREATE TABLE `customer_demographics` (\n  `cd_demo_sk` int(11) NOT NULL COMMENT \"\",\n  `cd_gender` char(1) NULL COMMENT \"\",\n  `cd_marital_status` char(1) NULL COMMENT \"\",\n  `cd_education_status` char(20) NULL COMMENT \"\",\n  `cd_purchase_estimate` int(11) NULL COMMENT \"\",\n  `cd_credit_rating` char(10) NULL COMMENT \"\",\n  `cd_dep_count` int(11) NULL COMMENT \"\",\n  `cd_dep_employed_count` int(11) NULL COMMENT \"\",\n  `cd_dep_college_count` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cd_demo_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cd_demo_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.date_dim":"CREATE TABLE `date_dim` (\n  `d_date_sk` int(11) NOT NULL COMMENT \"\",\n  `d_date_id` char(16) NOT NULL COMMENT \"\",\n  `d_date` date NULL COMMENT \"\",\n  `d_month_seq` int(11) NULL COMMENT \"\",\n  `d_week_seq` int(11) NULL COMMENT \"\",\n  `d_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_year` int(11) NULL COMMENT \"\",\n  `d_dow` int(11) NULL COMMENT \"\",\n  `d_moy` int(11) NULL COMMENT \"\",\n  `d_dom` int(11) NULL COMMENT \"\",\n  `d_qoy` int(11) NULL COMMENT \"\",\n  `d_fy_year` int(11) NULL COMMENT \"\",\n  `d_fy_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_fy_week_seq` int(11) NULL COMMENT \"\",\n  `d_day_name` char(9) NULL COMMENT \"\",\n  `d_quarter_name` char(6) NULL COMMENT \"\",\n  `d_holiday` char(1) NULL COMMENT \"\",\n  `d_weekend` char(1) NULL COMMENT \"\",\n  `d_following_holiday` char(1) NULL COMMENT \"\",\n  `d_first_dom` int(11) NULL COMMENT \"\",\n  `d_last_dom` int(11) NULL COMMENT \"\",\n  `d_same_day_ly` int(11) NULL COMMENT \"\",\n  `d_same_day_lq` int(11) NULL COMMENT \"\",\n  `d_current_day` char(1) NULL COMMENT \"\",\n  `d_current_week` char(1) NULL COMMENT \"\",\n  `d_current_month` char(1) NULL COMMENT \"\",\n  `d_current_quarter` char(1) NULL COMMENT \"\",\n  `d_current_year` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_date_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.household_demographics":"CREATE TABLE `household_demographics` (\n  `hd_demo_sk` int(11) NOT NULL COMMENT \"\",\n  `hd_income_band_sk` int(11) NULL COMMENT \"\",\n  `hd_buy_potential` char(15) NULL COMMENT \"\",\n  `hd_dep_count` int(11) NULL COMMENT \"\",\n  `hd_vehicle_count` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`hd_demo_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`hd_demo_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.income_band":"CREATE TABLE `income_band` (\n  `ib_income_band_sk` int(11) NOT NULL COMMENT \"\",\n  `ib_lower_bound` int(11) NULL COMMENT \"\",\n  `ib_upper_bound` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ib_income_band_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ib_income_band_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.item":"CREATE TABLE `item` (\n  `i_item_sk` int(11) NOT NULL COMMENT \"\",\n  `i_item_id` char(16) NOT NULL COMMENT \"\",\n  `i_rec_start_date` date NULL COMMENT \"\",\n  `i_rec_end_date` date NULL COMMENT \"\",\n  `i_item_desc` varchar(200) NULL COMMENT \"\",\n  `i_current_price` decimal(7, 2) NULL COMMENT \"\",\n  `i_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `i_brand_id` int(11) NULL COMMENT \"\",\n  `i_brand` char(50) NULL COMMENT \"\",\n  `i_class_id` int(11) NULL COMMENT \"\",\n  `i_class` char(50) NULL COMMENT \"\",\n  `i_category_id` int(11) NULL COMMENT \"\",\n  `i_category` char(50) NULL COMMENT \"\",\n  `i_manufact_id` int(11) NULL COMMENT \"\",\n  `i_manufact` char(50) NULL COMMENT \"\",\n  `i_size` char(20) NULL COMMENT \"\",\n  `i_formulation` char(20) NULL COMMENT \"\",\n  `i_color` char(20) NULL COMMENT \"\",\n  `i_units` char(10) NULL COMMENT \"\",\n  `i_container` char(10) NULL COMMENT \"\",\n  `i_manager_id` int(11) NULL COMMENT \"\",\n  `i_product_name` char(50) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`i_item_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`i_item_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.promotion":"CREATE TABLE `promotion` (\n  `p_promo_sk` int(11) NOT NULL COMMENT \"\",\n  `p_promo_id` char(16) NOT NULL COMMENT \"\",\n  `p_start_date_sk` int(11) NULL COMMENT \"\",\n  `p_end_date_sk` int(11) NULL COMMENT \"\",\n  `p_item_sk` int(11) NULL COMMENT \"\",\n  `p_cost` decimal(15, 2) NULL COMMENT \"\",\n  `p_response_target` int(11) NULL COMMENT \"\",\n  `p_promo_name` char(50) NULL COMMENT \"\",\n  `p_channel_dmail` char(1) NULL COMMENT \"\",\n  `p_channel_email` char(1) NULL COMMENT \"\",\n  `p_channel_catalog` char(1) NULL COMMENT \"\",\n  `p_channel_tv` char(1) NULL COMMENT \"\",\n  `p_channel_radio` char(1) NULL COMMENT \"\",\n  `p_channel_press` char(1) NULL COMMENT \"\",\n  `p_channel_event` char(1) NULL COMMENT \"\",\n  `p_channel_demo` char(1) NULL COMMENT \"\",\n  `p_channel_details` varchar(100) NULL COMMENT \"\",\n  `p_purpose` char(15) NULL COMMENT \"\",\n  `p_discount_active` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`p_promo_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`p_promo_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.store":"CREATE TABLE `store` (\n  `s_store_sk` int(11) NOT NULL COMMENT \"\",\n  `s_store_id` char(16) NOT NULL COMMENT \"\",\n  `s_rec_start_date` date NULL COMMENT \"\",\n  `s_rec_end_date` date NULL COMMENT \"\",\n  `s_closed_date_sk` int(11) NULL COMMENT \"\",\n  `s_store_name` varchar(50) NULL COMMENT \"\",\n  `s_number_employees` int(11) NULL COMMENT \"\",\n  `s_floor_space` int(11) NULL COMMENT \"\",\n  `s_hours` char(20) NULL COMMENT \"\",\n  `s_manager` varchar(40) NULL COMMENT \"\",\n  `s_market_id` int(11) NULL COMMENT \"\",\n  `s_geography_class` varchar(100) NULL COMMENT \"\",\n  `s_market_desc` varchar(100) NULL COMMENT \"\",\n  `s_market_manager` varchar(40) NULL COMMENT \"\",\n  `s_division_id` int(11) NULL COMMENT \"\",\n  `s_division_name` varchar(50) NULL COMMENT \"\",\n  `s_company_id` int(11) NULL COMMENT \"\",\n  `s_company_name` varchar(50) NULL COMMENT \"\",\n  `s_street_number` varchar(10) NULL COMMENT \"\",\n  `s_street_name` varchar(60) NULL COMMENT \"\",\n  `s_street_type` char(15) NULL COMMENT \"\",\n  `s_suite_number` char(10) NULL COMMENT \"\",\n  `s_city` varchar(60) NULL COMMENT \"\",\n  `s_county` varchar(30) NULL COMMENT \"\",\n  `s_state` char(2) NULL COMMENT \"\",\n  `s_zip` char(10) NULL COMMENT \"\",\n  `s_country` varchar(20) NULL COMMENT \"\",\n  `s_gmt_offset` decimal(5, 2) NULL COMMENT \"\",\n  `s_tax_precentage` decimal(5, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`s_store_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`s_store_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.store_returns":"CREATE TABLE `store_returns` (\n  `sr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `sr_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `sr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `sr_return_time_sk` int(11) NULL COMMENT \"\",\n  `sr_customer_sk` int(11) NULL COMMENT \"\",\n  `sr_cdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_hdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_addr_sk` int(11) NULL COMMENT \"\",\n  `sr_store_sk` int(11) NULL COMMENT \"\",\n  `sr_reason_sk` int(11) NULL COMMENT \"\",\n  `sr_return_quantity` int(11) NULL COMMENT \"\",\n  `sr_return_amt` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_tax` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_amt_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `sr_fee` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `sr_refunded_cash` decimal(7, 2) NULL COMMENT \"\",\n  `sr_reversed_charge` decimal(7, 2) NULL COMMENT \"\",\n  `sr_store_credit` decimal(7, 2) NULL COMMENT \"\",\n  `sr_net_loss` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`sr_item_sk`, `sr_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`sr_item_sk`, `sr_ticket_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "standard_sqlset_1618283896.store_sales":"CREATE TABLE `store_sales` (\n  `ss_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ss_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `ss_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ss_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ss_customer_sk` int(11) NULL COMMENT \"\",\n  `ss_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_addr_sk` int(11) NULL COMMENT \"\",\n  `ss_store_sk` int(11) NULL COMMENT \"\",\n  `ss_promo_sk` int(11) NULL COMMENT \"\",\n  `ss_quantity` int(11) NULL COMMENT \"\",\n  `ss_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ss_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_discount_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ss_coupon_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_paid` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_paid_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_profit` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ss_item_sk`, `ss_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);"
  },
  "table_row_count":{
    "standard_sqlset_1618283896.household_demographics":{
      "household_demographics":7200
    },
    "standard_sqlset_1618283896.customer_demographics":{
      "customer_demographics":1920800
    },
    "standard_sqlset_1618283896.catalog_sales":{
      "catalog_sales":1441548
    },
    "standard_sqlset_1618283896.promotion":{
      "promotion":300
    },
    "standard_sqlset_1618283896.customer":{
      "customer":100000
    },
    "standard_sqlset_1618283896.store_sales":{
      "store_sales":2880404
    },
    "standard_sqlset_1618283896.date_dim":{
      "date_dim":73049
    },
    "standard_sqlset_1618283896.income_band":{
      "income_band":20
    },
    "standard_sqlset_1618283896.store_returns":{
      "store_returns":287514
    },
    "standard_sqlset_1618283896.store":{
      "store":12
    },
    "standard_sqlset_1618283896.catalog_returns":{
      "catalog_returns":144067
    },
    "standard_sqlset_1618283896.item":{
      "item":18000
    },
    "standard_sqlset_1618283896.customer_address":{
      "customer_address":50000
    }
  },
  "session_variables":"{\"enable_resource_group\":false,\"enable_show_all_variables\":false,\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":false,\"new_planner_optimize_timeout\":300000,\"force_schedule_local\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648,\"cbo_max_reorder_node_use_dp\":10,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"query_timeout\":60,\"cbo_max_reorder_node\":50,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"broadcast_right_table_scale_factor\":10,\"disable_streaming_preaggregations\":false,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"statistic_collect_parallel\":1,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_exchange_pass_through\":true,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"enable_replicated_storage\":false,\"max_allowed_packet\":1048576,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics":{
    "standard_sqlset_1618283896.household_demographics":{
      "hd_income_band_sk":"[1.0, 20.0, 0.0, 4.0, 20.0] ESTIMATE",
      "hd_demo_sk":"[1.0, 7200.0, 0.0, 4.0, 7141.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.customer_demographics":{
      "cd_demo_sk":"[1.0, 1920800.0, 0.0, 4.0, 1942840.0] ESTIMATE",
      "cd_marital_status":"[-Infinity, Infinity, 0.0, 1.0, 5.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.catalog_sales":{
      "cs_order_number":"[1.0, 160000.0, 0.0, 4.0, 160761.0] ESTIMATE",
      "cs_item_sk":"[1.0, 18000.0, 0.0, 4.0, 17822.0] ESTIMATE",
      "cs_ext_list_price":"[1.29, 29976.0, 0.004891269662890171, 16.0, 557258.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.promotion":{
      "p_promo_sk":"[1.0, 300.0, 0.0, 4.0, 302.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.customer":{
      "c_current_hdemo_sk":"[1.0, 7200.0, 0.03431, 4.0, 7141.0] ESTIMATE",
      "c_first_sales_date_sk":"[2448998.0, 2452648.0, 0.03518, 4.0, 3650.0] ESTIMATE",
      "c_current_addr_sk":"[1.0, 50000.0, 0.0, 4.0, 43656.0] ESTIMATE",
      "c_customer_sk":"[1.0, 100000.0, 0.0, 4.0, 99554.0] ESTIMATE",
      "c_current_cdemo_sk":"[17.0, 1920788.0, 0.03438, 4.0, 94651.0] ESTIMATE",
      "c_first_shipto_date_sk":"[2449028.0, 2452678.0, 0.03443, 4.0, 3646.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.store_sales":{
      "ss_customer_sk":"[1.0, 100000.0, 0.04504645876064608, 4.0, 91002.0] ESTIMATE",
      "ss_cdemo_sk":"[15.0, 1920797.0, 0.04502840573752848, 4.0, 226785.0] ESTIMATE",
      "ss_promo_sk":"[1.0, 300.0, 0.04495341625688619, 4.0, 302.0] ESTIMATE",
      "ss_addr_sk":"[1.0, 50000.0, 0.04512387845593882, 4.0, 49911.0] ESTIMATE",
      "ss_ticket_number":"[1.0, 240000.0, 0.0, 4.0, 241797.0] ESTIMATE",
      "ss_wholesale_cost":"[1.0, 100.0, 0.04514054278497044, 16.0, 10030.0] ESTIMATE",
      "ss_sold_date_sk":"[2450816.0, 2452642.0, 0.04516484493147489, 4.0, 1824.0] ESTIMATE",
      "ss_item_sk":"[1.0, 18000.0, 0.0, 4.0, 17822.0] ESTIMATE",
      "ss_coupon_amt":"[0.0, 17588.25, 0.0450763156834944, 16.0, 209903.0] ESTIMATE",
      "ss_store_sk":"[1.0, 10.0, 0.04514436169370686, 4.0, 6.0] ESTIMATE",
      "ss_hdemo_sk":"[1.0, 7200.0, 0.04507944024518783, 4.0, 7141.0] ESTIMATE",
      "ss_list_price":"[1.0, 200.0, 0.0451335993145406, 16.0, 19803.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.date_dim":{
      "d_date_sk":"[2415022.0, 2488070.0, 0.0, 4.0, 73941.0] ESTIMATE",
      "d_year":"[1900.0, 2100.0, 0.0, 4.0, 202.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.income_band":{
      "ib_income_band_sk":"[1.0, 20.0, 0.0, 4.0, 20.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.store_returns":{
      "sr_ticket_number":"[1.0, 240000.0, 0.0, 4.0, 170153.0] ESTIMATE",
      "sr_item_sk":"[1.0, 18000.0, 0.0, 4.0, 17822.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.store":{
      "s_zip":"[-Infinity, Infinity, 0.0, 5.0, 2.0] ESTIMATE",
      "s_store_name":"[-Infinity, Infinity, 0.0, 4.25, 8.0] ESTIMATE",
      "s_store_sk":"[1.0, 12.0, 0.0, 4.0, 12.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.catalog_returns":{
      "cr_refunded_cash":"[0.0, 22110.68, 0.01977552111170497, 16.0, 73878.0] ESTIMATE",
      "cr_order_number":"[2.0, 160000.0, 0.0, 4.0, 96275.0] ESTIMATE",
      "cr_reversed_charge":"[0.0, 17158.23, 0.019726932607745006, 16.0, 55169.0] ESTIMATE",
      "cr_item_sk":"[1.0, 18000.0, 0.0, 4.0, 17689.0] ESTIMATE",
      "cr_store_credit":"[0.0, 16255.33, 0.0197546974671507, 16.0, 54743.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.item":{
      "i_current_price":"[0.09, 99.99, 0.0025, 16.0, 2717.0] ESTIMATE",
      "i_product_name":"[-Infinity, Infinity, 0.002, 18.002777777777776, 18022.0] ESTIMATE",
      "i_color":"[-Infinity, Infinity, 0.0025, 5.3742222222222225, 92.0] ESTIMATE",
      "i_item_sk":"[1.0, 18000.0, 0.0, 4.0, 17822.0] ESTIMATE"
    },
    "standard_sqlset_1618283896.customer_address":{
      "ca_street_number":"[-Infinity, Infinity, 0.03064, 2.80616, 1001.0] ESTIMATE",
      "ca_zip":"[-Infinity, Infinity, 0.03078, 4.8461, 3664.0] ESTIMATE",
      "ca_city":"[-Infinity, Infinity, 0.03038, 8.6713, 684.0] ESTIMATE",
      "ca_street_name":"[-Infinity, Infinity, 0.02958, 8.45012, 6900.0] ESTIMATE",
      "ca_address_sk":"[1.0, 50000.0, 0.0, 4.0, 50332.0] ESTIMATE"
    }
  },
  "be_number":1,
  "be_core_stat":{
    "numOfHardwareCoresPerBe":"{\"213110\":104}",
    "cachedAvgNumOfHardwareCores":104
  },
  "exception":[

  ],
  "version":"UNKNOWN",
  "commit_version":"4768d3fbf"
}
